package com.oscar.springaidemo.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oscar.springaidemo.model.InterviewTest;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface InterviewDAO extends BaseMapper<InterviewTest> {

    @Select("SELECT COUNT(1) FROM db_oscar_practice.interview_test ")
    Integer select1();

    List<InterviewTest> selectBySearchKey(@Param("kType") Integer kType, @Param("pageNo") Integer pageNo, @Param("pageSize") Integer pageSize, @Param("searchKey") String searchKey);

}